/**
 * Copyright 2014,Peak Tai 台俊峰(taijunfeng_it@sina.com).
 * 
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not
 * use this file except in compliance with the License. You may obtain a copy of
 * the License at
 * 
 * 		http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 * License for the specific language governing permissions and limitations under
 * the License.
 */

package com.cenluan.activity.member;

import java.util.List;

public class ActivityMemberService {
	/**
	 * 查询活动成员列表
	 * 
	 * @param activityId
	 * @param state
	 * @return
	 */
	static List<ActivityMember> list(String activityId, String state) {
		StringBuilder sql = new StringBuilder();
		sql.append(" select * ");
		sql.append(" from t_activity_member ");
		sql.append(" where activityId=? ");
		sql.append(" and state=? ");
		sql.append(" order by joinTime desc,applyTime desc ");
		return ActivityMember.dao.find(sql.toString(), activityId, state);
	}
}
